The dataset has been retreived from Kaggle

The data contains sales of six months of the year 2023

Conclusion:

• From this analysis, we can say that all stores’ sales are good where sales of store at Lower Manhattan is higher compared to other locations with 71742 sales

Conclusion:

• There are highest sales for Coffee with total 89250 sales followed by Tea with 69737 sales

Conclusion:

• The highest selling product was Brewed Chai Tea with 26250 sales.
• The second highest selling product was Gourmet Brewed Coffee with 25973 sales.

Conclusion

• There are highest sales for Regular size with total sales of 70186.
• The second highest sales are for Large size with total sales of 68540.
• NOTE: Not Defined refers to some products where the item size is fixed such as pastry, etc.

Conclusion

• There is highest profit gained for Barista Espresso with total sum of 91406.2 .
• The second highest profit was gained with Brewed Black Tea with total sum of 77081.95 .
• The least profit was gained by Green Beans with total sum of 1340 .

Conclusion

• The highest profit was earned on Coffee category of total sum 269952.45 .
• The second highest profit was earned on Tea category of total sum 196405.95 .
• The least profit was earned on Packaged Chocolate category of total sum 4407.64 .

Conclusion:

• The overall sales are higher in the month of June with 50942 sales followed by the month of May with 48233 sales
• The data contains sales of six months of the year 2023
• The least sales were happened in the month of February with 23556 sales followed by the month of January with 24870 sales

Conclusion:

• The sales on Monday and Friday are comparitively high with 31231 and 31207 sales respectively.
• There is huge dip in sales on Saturday from Friday with 29614 and the sales on Saturday were very less than all other days.
• There are average sales on Tuesday and Wednesday with 30449 and 30625 sales respectively.

Conclusion

• Sales were recorded only between 6th and 20th hour.
• Sales were highest on 10th hour with a total of 26713 sales followed by 9th and 8th hour with 25370 and 25197 sales respectively.
• Least sales were happened on 20th hour with a total of 880 sales followed by the 6th hour with 6865 sales.